package org.geekbang.dbexcel.domain;

import com.alibaba.fastjson.annotation.JSONField;
import lombok.Data;

import java.util.List;

/**
 * @author 孙红瑞
 * @ClassName Table.java
 * @Description 表相关属性
 * @createTime 2021年02月03日 15:44:00
 */
@Data
public class Table {
    /**
     * 表名
     */
    @JSONField(name="TABLE_NAME")
    private String tableName;
    /**
     * 表备注
     */
    @JSONField(name="TABLE_COMMENT")
    private String tableComment;

    @JSONField(name="TABLE_CATALOG")
    private String tableCatalog;
    @JSONField(name="TABLE_SCHEMA")
    private String tableSchema;
    @JSONField(name="ENGINE")
    private String engine;
    @JSONField(name="TABLE_TYPE")
    private String tableType;
    @JSONField(name="TABLE_ROWS")
    private String tableRows;
    @JSONField(name="AVG_ROW_LENGTH")
    private String avgRowLength;
    @JSONField(name="DATA_LENGTH")
    private String dataLength;
    @JSONField(name="DATA_FREE")
    private String dataFree;
    @JSONField(name="INDEX_LENGTH")
    private String indexLength;
    @JSONField(name="ROW_FORMAT")
    private String rowFormat;
    @JSONField(name="AUTO_INCREMENT")
    private String autoIncrement;
    @JSONField(name="VERSION")
    private String version;
    @JSONField(name="CREATE_OPTIONS")
    private String createOptions;
    @JSONField(name="CREATE_TIME")
    private String createTime;
    @JSONField(name="MAX_DATA_LENGTH")
    private String maxDataLength;
    @JSONField(name="TABLE_COLLATION")
    private String tableCollation;

    /**
     * 建表语句
     */
    private String createSql;
    /**
     * 字段信息
     */
    private List<Column> columns;
}
